UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DUU7qTq3m7g2bQ4BM3XFSESS7uX7muBPKhO5wkZldnI='
WHERE
key_id = '816598a95698cd9f74f997f6abb36d341a2bf082b54c261a32abbf2be0eb3ef5'
AND (
token = 'DUU7qTq3m7g2bQ4BM3XFSESS7uX7muBPKhO5wkZldnI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)