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