UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'MW+0EpgLMejpQxNp4f2b9K/U3Hd0AAtA8awWEBpifck=' 
WHERE 
  key_id = '1a423d178e3db36b65499e520dfefc51cac8027b9180a738c88b75837ddbce79' 
  AND (
    token = 'MW+0EpgLMejpQxNp4f2b9K/U3Hd0AAtA8awWEBpifck=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00063