UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bvGs6JXmQC4r39fRUHFvQOMpx7vl2NXSFwCNEsNRg10=' 
WHERE 
  key_id = '1433b9b4ca799047f6de5184ac5a753f60bcd69b75b9af3b0f150dbd251b3593' 
  AND (
    token = 'bvGs6JXmQC4r39fRUHFvQOMpx7vl2NXSFwCNEsNRg10=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027