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