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