UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U5opB9O8qk4XSOzfmdMKFsOceP5kVesSMysIhFAYVFI='
WHERE
key_id = 'b8360543d63bf1935ee2f5415b3fb251de50bdb0638e6a37868bb084852ad3ac'
AND (
token = 'U5opB9O8qk4XSOzfmdMKFsOceP5kVesSMysIhFAYVFI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)