UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h7o62tV2hoosgKwuOfWP+bztwZgE9JKCX4qcPTkFXD4='
WHERE
key_id = 'c6e9b55e682bf78f6693154f86fd435f34f85407f920c5955ea544428b71f5ff'
AND (
token = 'h7o62tV2hoosgKwuOfWP+bztwZgE9JKCX4qcPTkFXD4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)