UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gdXOfshucKhP2QdRZVm4FqUKkydBfRd63O9UJQdSEOg='
WHERE
key_id = '0078bcd09bdacba4b1dffc6663a4fb02664ed5f0f84b8ca4ca4f43e3de404aae'
AND (
token = 'gdXOfshucKhP2QdRZVm4FqUKkydBfRd63O9UJQdSEOg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)