UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7lGZKfKt20wi7Bybq4IH+WaRG15tG1wRW127DNe370w='
WHERE
key_id = '9ff4281abdf4451e8a9a9de5fec343f352baa0c7d26a1e142c1de9c50e39b80f'
AND (
token = '7lGZKfKt20wi7Bybq4IH+WaRG15tG1wRW127DNe370w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)