UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v0JiWP7Wtf8ZxANXxwguGCAWZ/BgNgXDs4mKF2/gC10='
WHERE
key_id = '5748bc4f696a43710d0cd5c1f5b3037116e7397c40305da31cffd971caf638ea'
AND (
token = 'v0JiWP7Wtf8ZxANXxwguGCAWZ/BgNgXDs4mKF2/gC10='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)