UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fV5LdG/iJdBOEj1KtoUcW17TDdRjT8c6PuseVmHZbyg='
WHERE
key_id = '0175beca2a83b36aa895ac8f45629c9f8b6a9f58e1b803a80d3dd6cdd96f9500'
AND (
token = 'fV5LdG/iJdBOEj1KtoUcW17TDdRjT8c6PuseVmHZbyg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)