UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nngipDYzgrMGsyCmhLSMPfoDzzDLak5Iem7fLCI2gz0='
WHERE
key_id = '6ee4fbf0a113b00ce5245f2407f6d835ab76d7e8051ebcfaff492cc216532146'
AND (
token = 'nngipDYzgrMGsyCmhLSMPfoDzzDLak5Iem7fLCI2gz0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)