UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'moh9GFTvMwkjlU7t33ge9qDqfODpK5oLlh5A5M1Bh0A='
WHERE
key_id = 'f9dafe0371864ea0df579e6db15ab3203539b3f18547dc7c2b263c32d9bc1472'
AND (
token = 'moh9GFTvMwkjlU7t33ge9qDqfODpK5oLlh5A5M1Bh0A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)