UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gJ4cPlauwDqijkFZzFuhd4+xvBsvluN8J57gCH8nUzE='
WHERE
key_id = 'f5003f1c1bd627a3e60db82a337ee5fdf322aa1a35ce77c45b214aefe5d92f7a'
AND (
token = 'gJ4cPlauwDqijkFZzFuhd4+xvBsvluN8J57gCH8nUzE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)