UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7NvlsUPrhEhMZn86JZIyIrP3iDMzQ7T/LWqRcn88xXc='
WHERE
key_id = '1afbcce53a8e787fc6f7f29cb0892c6063d098d52d12c00d0ea880253e427fcd'
AND (
token = '7NvlsUPrhEhMZn86JZIyIrP3iDMzQ7T/LWqRcn88xXc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)