UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lJ/zGfdWhk5fd6K4wIHRDmjSLLCiY/AMdjXr0GmrYgw='
WHERE
key_id = 'd98ad486c9678d1216aad5ca1ae237c2325a52af6d183846736b81ee5caf8221'
AND (
token = 'lJ/zGfdWhk5fd6K4wIHRDmjSLLCiY/AMdjXr0GmrYgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)