UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aPxFNNhwmBdK6MjKeZJCz/7s1MxYNKzVC5OMv6QEWt0='
WHERE
key_id = '504a8f1c8b43917399c71d3d94b84a797e60599957d9d78ecea2ec62ef91ca6a'
AND (
token = 'aPxFNNhwmBdK6MjKeZJCz/7s1MxYNKzVC5OMv6QEWt0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)