UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'EdJG7CVvB5DTaeYXM0XQXf61qE/ndjzFG5wq8RIO5CU=' 
WHERE 
  key_id = '4e014ae8cf79d1fde945b26df7de247bb9b863dbadc9b296bb1df79c806dd28c' 
  AND (
    token = 'EdJG7CVvB5DTaeYXM0XQXf61qE/ndjzFG5wq8RIO5CU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023