UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '79kwTAaoVNFvECHRbczih93fwBUsf6HNtAkr9qtriG8='
WHERE
key_id = '7b9a8770a2aa38191a830cce5dbf80e31258660c443e9258c68a9380d4ad585e'
AND (
token = '79kwTAaoVNFvECHRbczih93fwBUsf6HNtAkr9qtriG8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)