UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B8XHP6cYciZcAZIgjCqV38gc8J7aQqvDZZbwmPh1Ggg='
WHERE
key_id = '620f851a381c2ef3bdf5aaedc91e54ddab786741b238c2f1e1281442f407ac88'
AND (
token = 'B8XHP6cYciZcAZIgjCqV38gc8J7aQqvDZZbwmPh1Ggg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)