UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vlNpDCRxA5pGB7zNZjVmmwo1GEYAklN/gjE56pkKbqY=' 
WHERE 
  key_id = 'e2e85a42343339668e6aa091f105aad8b815358cea0cf8b9d64c9ede13fddd9c' 
  AND (
    token = 'vlNpDCRxA5pGB7zNZjVmmwo1GEYAklN/gjE56pkKbqY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021