UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n38nz1iALuLyYbj7S7IPSgn0OwIi4Pw9MaDAabwZvjk='
WHERE
key_id = '847bd8a9fc0f36883a49666b5fc2aaa46d94f17c0da284015250e8a17dc53011'
AND (
token = 'n38nz1iALuLyYbj7S7IPSgn0OwIi4Pw9MaDAabwZvjk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)