UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2vV27wqN75POaHwrZWcnc0bUUagJIfbiN5zHn8z0kLA='
WHERE
key_id = '770b65b285be89c9a060c4a30cb414b95ed4c5e9243a8e577bf8a9b82cafc790'
AND (
token = '2vV27wqN75POaHwrZWcnc0bUUagJIfbiN5zHn8z0kLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)