UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oVNhA6WvkvLZwAXWno15CTtFM/CNGVuGMUMFAL4oPwE='
WHERE
key_id = 'e85d5ca2e0a214f0374b89dea12306c7a805dea98645319df1bfb58abefe0df9'
AND (
token = 'oVNhA6WvkvLZwAXWno15CTtFM/CNGVuGMUMFAL4oPwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)