UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'adxX+Vsq0olytgfOFmHDR3SLN/epqadBWgHix41p85c=' 
WHERE 
  key_id = 'd0dddfc1929aee8daf9f95e4cff437b06e7bc6cf2917d7e22e98107d611695ed' 
  AND (
    token = 'adxX+Vsq0olytgfOFmHDR3SLN/epqadBWgHix41p85c=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042