UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NLFJfK6t8EWBzHJvaycooJR2fqrtEqIth6Q7D8bwkaE=' 
WHERE 
  key_id = '91d36742a81fc5a2dc396a3e81435e4f9be7f285d563c4620e4152afebae0379' 
  AND (
    token = 'NLFJfK6t8EWBzHJvaycooJR2fqrtEqIth6Q7D8bwkaE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034