UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5ZFecycI54gjJ4eHKRJ9mjX5i2ez2YOB0KmpystM4Co='
WHERE
key_id = 'fcd4636098a90f6faecffd6cd404a1d8a61758be01ad20f2439e49cff7bb27f5'
AND (
token = '5ZFecycI54gjJ4eHKRJ9mjX5i2ez2YOB0KmpystM4Co='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)