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