UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BebhNWZDXrF6xwxnzxrgb813GVleFPGLF7LJmuRHgYk='
WHERE
key_id = '96ca4953fa484b8cd2e87fee6dfa85772aa82cefd0eee7fd376c2ecca65fb53a'
AND (
token = 'BebhNWZDXrF6xwxnzxrgb813GVleFPGLF7LJmuRHgYk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)