UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bNsHljzyi42KwPiu2l+bhtFjCMYj+npxVVNxOJSLHWM='
WHERE
key_id = 'c1c7b8d5ea0d20715d6ee021e463e68586c848fc4fb2dda45b97a0a7c2e23b3c'
AND (
token = 'bNsHljzyi42KwPiu2l+bhtFjCMYj+npxVVNxOJSLHWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)