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