UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'gYK8UdbZHmSpiOffWgiMKD+1JK8IuLpzZbS67W2UpyE=' 
WHERE 
  key_id = '7093b7a015b9247c8c7ec3228f75c0484d3f58a91d6ad567ca9e802477024aea' 
  AND (
    token = 'gYK8UdbZHmSpiOffWgiMKD+1JK8IuLpzZbS67W2UpyE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032