UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 's4ofiqr/q4cqVCcilZzyk7I609rUiDNR3VyfznZA054=' 
WHERE 
  key_id = '7a4994b9445abfb7c59f00a39a4e706465462ad3529a45650795b566d9fc3663' 
  AND (
    token = 's4ofiqr/q4cqVCcilZzyk7I609rUiDNR3VyfznZA054=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043