UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z+hi1sgNLyO5ZRZYGlYiBO7DTVSdpS81k5TxY3JMxAU='
WHERE
key_id = '598e1e9d368d79515b839c81225a1b97be89f97c3b208d9285019c34ebb4c530'
AND (
token = 'z+hi1sgNLyO5ZRZYGlYiBO7DTVSdpS81k5TxY3JMxAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)