UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ESAhLojdA6vTR7YlWE3bBlW21i7UN7jShkT3U30z//o='
WHERE
key_id = '418e64be8524d50ecba0a8c1d5c8bf52e3679e8b046fe8da14e61844b2cd3fb7'
AND (
token = 'ESAhLojdA6vTR7YlWE3bBlW21i7UN7jShkT3U30z//o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)