UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'H4TXDK/kj3f2YpSl1xzDQdfj4mZ+5gpa/UQbTgrqB2w=' 
WHERE 
  key_id = 'e85af4b09379baea377911d5bd0e0455f3f2732a4f2289b59ad67adfa7d13466' 
  AND (
    token = 'H4TXDK/kj3f2YpSl1xzDQdfj4mZ+5gpa/UQbTgrqB2w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025