UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xPi3AOebks7g56+8RcizhunqN6+iEMYWF6UN7GKfne0=' 
WHERE 
  key_id = '998694a194c7e5b5439f124328c7a369b98a23e5834515c7498a46e0423e0ea5' 
  AND (
    token = 'xPi3AOebks7g56+8RcizhunqN6+iEMYWF6UN7GKfne0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040