UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'BTtamcFgh7YtM/0EOmqiOJmHT0NSqhT0zhNAXvR9Ylw=' 
WHERE 
  key_id = '2450eb97da917766e7ae93b4c16e8525f55cb7e861e687beff3717c745b243f6' 
  AND (
    token = 'BTtamcFgh7YtM/0EOmqiOJmHT0NSqhT0zhNAXvR9Ylw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027