UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VsD32HqSoD18JEeaWGNQzl5ZhuD4JyB3WAR1OE9gB34='
WHERE
key_id = 'b4e3833f31d8179247aaf97a995e6a6f3011845e31e1e7033e182a18a59500c7'
AND (
token = 'VsD32HqSoD18JEeaWGNQzl5ZhuD4JyB3WAR1OE9gB34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)