UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'gWYC25PRck3hS8O1u6HNKQWeMTNd1Yk6cGd7LIRlsEo=' 
WHERE 
  key_id = '94811c663cca9255a5f092a4fc8ca32dcaf2a31cfc0e5e14a306347ec44b0c32' 
  AND (
    token = 'gWYC25PRck3hS8O1u6HNKQWeMTNd1Yk6cGd7LIRlsEo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032